= 70) { return array('grade' => 'A', 'remark' => 'Excellent', 'class' => 'grade-A'); } elseif ($score >= 60) { return array('grade' => 'B', 'remark' => 'Good', 'class' => 'grade-B'); } elseif ($score >= 55) { return array('grade' => 'C', 'remark' => 'Credit', 'class' => 'grade-C'); } elseif ($score >= 50) { return array('grade' => 'D', 'remark' => 'Pass', 'class' => 'grade-D'); } else { return array('grade' => 'F', 'remark' => 'Fail', 'class' => 'grade-F'); } } // Function to determine overall grade function getOverallGrade($average) { if ($average >= 70) return 'A'; elseif ($average >= 60) return 'B'; elseif ($average >= 55) return 'C'; elseif ($average >= 50) return 'D'; else return 'F'; } // Function to calculate student average based on class type function calculateStudentAverage($student_results, $klass) { $student_total = 0; $subject_count = count($student_results); // Calculate total score foreach($student_results as $row) { $student_total += ($row['test'] + $row['exam']); } // For SS 2 and SS 3 classes if (strpos($klass, 'SS 2') !== false || strpos($klass, 'SS 3') !== false) { // Use minimum of 9 subjects or actual number of subjects if more than 9 $base_subject_count = max(9, $subject_count); return $subject_count > 0 ? $student_total / $base_subject_count : 0; } // For other classes - use actual number of subjects written else { return $subject_count > 0 ? $student_total / $subject_count : 0; } } if(isset($_POST['filter'])) { $acyear = $_POST['acyear']; $term = $_POST['term']; $klass = $_POST['klass']; try { // Check if data exists $check_query = "SELECT COUNT(*) as count FROM marks WHERE acyear = ? AND term = ? AND klass = ?"; $check_stmt = $DBcon->prepare($check_query); $check_stmt->execute([$acyear, $term, $klass]); $check_result = $check_stmt->fetch(PDO::FETCH_ASSOC); if($check_result['count'] > 0) { // Get students with names $students_query = "SELECT DISTINCT m.regno, s.fullname FROM marks m LEFT JOIN students_info s ON m.regno = s.regno WHERE m.acyear = ? AND m.term = ? AND m.klass = ? ORDER BY s.fullname"; $students_stmt = $DBcon->prepare($students_query); $students_stmt->execute([$acyear, $term, $klass]); $students = $students_stmt->fetchAll(PDO::FETCH_ASSOC); // Get subjects $subjects_query = "SELECT DISTINCT subject FROM marks WHERE acyear = ? AND term = ? AND klass = ? ORDER BY subject"; $subjects_stmt = $DBcon->prepare($subjects_query); $subjects_stmt->execute([$acyear, $term, $klass]); $subjects = $subjects_stmt->fetchAll(PDO::FETCH_ASSOC); // Calculate student averages for positioning $student_averages = array(); $student_totals = array(); foreach($students as $student) { // Get all results for this student $student_results_query = "SELECT * FROM marks WHERE regno = ? AND acyear = ? AND term = ? AND klass = ?"; $student_results_stmt = $DBcon->prepare($student_results_query); $student_results_stmt->execute([$student['regno'], $acyear, $term, $klass]); $student_results = $student_results_stmt->fetchAll(PDO::FETCH_ASSOC); // Calculate average using the new function $student_average = calculateStudentAverage($student_results, $klass); $student_averages[$student['regno']] = $student_average; // Calculate total score $total_score = 0; foreach($student_results as $row) { $total_score += ($row['test'] + $row['exam']); } $student_totals[$student['regno']] = $total_score; } // Sort students by average (descending) arsort($student_averages); // Assign positions $positions = array(); $position = 1; foreach($student_averages as $regno => $average) { $positions[$regno] = $position++; } // Display results table if(count($students) > 0 && count($subjects) > 0) { echo ''; } } else { echo ''; } } catch(PDOException $e) { echo ''; } } ?>